﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using System.Collections.Generic;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VVADBLATT
    {
        public DataSet GETVADB(Dictionary<string, object> pm)
        {
            dwData = TBMain.NewRow();
            dwData["VADMANDANT"] = app.Mandant;
            dwData["VADKOLL"] = pm["KOLL"].ToString();
            dwData["VADART"] = pm["ART"].ToString();
            SResult = QVAD01(dwData);
            return SResult;
        }
    }
    public partial class VVADBLATT
    { 
        public string VADMANDANT { get { if (dwMaster == null) return ""; return dwMaster["VADMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADMANDANT"] = value; OnPropertyChanged("VADMANDANT", value); } } //lENGth 2
        public string VADKOLL { get { if (dwMaster == null) return ""; return dwMaster["VADKOLL"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADKOLL"] = value; OnPropertyChanged("VADKOLL", value); } } //lENGth 5
        public string VADART { get { if (dwMaster == null) return ""; return dwMaster["VADART"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADART"] = value; OnPropertyChanged("VADART", value); } } //lENGth 24
        public string VADSPRKZ { get { if (dwMaster == null) return ""; return dwMaster["VADSPRKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSPRKZ"] = value; OnPropertyChanged("VADSPRKZ", value); } } //lENGth 1
        public string VADARTBEZ { get { if (dwMaster == null) return ""; return dwMaster["VADARTBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADARTBEZ"] = value; OnPropertyChanged("VADARTBEZ", value); } } //lENGth 30
        public string VADSTDTXT { get { if (dwMaster == null) return ""; return dwMaster["VADSTDTXT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSTDTXT"] = value; OnPropertyChanged("VADSTDTXT", value); } } //lENGth 20
        public string VADPFCODE { get { if (dwMaster == null) return ""; return dwMaster["VADPFCODE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADPFCODE"] = value; OnPropertyChanged("VADPFCODE", value); } } //lENGth 5
        public string VADETG { get { if (dwMaster == null) return ""; return dwMaster["VADETG"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADETG"] = value; OnPropertyChanged("VADETG", value); } } //lENGth 1
        public string VADSTDART { get { if (dwMaster == null) return ""; return dwMaster["VADSTDART"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSTDART"] = value; OnPropertyChanged("VADSTDART", value); } } //lENGth 10
        public string VADSTDAUF1 { get { if (dwMaster == null) return ""; return dwMaster["VADSTDAUF1"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSTDAUF1"] = value; OnPropertyChanged("VADSTDAUF1", value); } } //lENGth 1
        public string VADSTDAUF2 { get { if (dwMaster == null) return ""; return dwMaster["VADSTDAUF2"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSTDAUF2"] = value; OnPropertyChanged("VADSTDAUF2", value); } } //lENGth 1
        public string VADSTDAUF3 { get { if (dwMaster == null) return ""; return dwMaster["VADSTDAUF3"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADSTDAUF3"] = value; OnPropertyChanged("VADSTDAUF3", value); } } //lENGth 1
        public string VADFILLER { get { if (dwMaster == null) return ""; return dwMaster["VADFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADFILLER"] = value; OnPropertyChanged("VADFILLER", value); } } //lENGth 34
        public string VADAENDZL { get { if (dwMaster == null) return ""; return dwMaster["VADAENDZL"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADAENDZL"] = value; OnPropertyChanged("VADAENDZL", value); } } //lENGth 3
        public string VADAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["VADAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADAENDBEN"] = value; OnPropertyChanged("VADAENDBEN", value); } } //lENGth 8
        public string VADAENDDAT { get { if (dwMaster == null) return ""; return dwMaster["VADAENDDAT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADAENDDAT"] = value; OnPropertyChanged("VADAENDDAT", value); } } //lENGth 6
        public string VADNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["VADNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADNEUBEN"] = value; OnPropertyChanged("VADNEUBEN", value); } } //lENGth 8
        public string VADNEUDAT { get { if (dwMaster == null) return ""; return dwMaster["VADNEUDAT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VADNEUDAT"] = value; OnPropertyChanged("VADNEUDAT", value); } } //lENGth 6

    }
}
